{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Input","Calculations","copyright_disclaimer","Certificate of Tax Levy","Explanation","Extension","InfoPage"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Input","index":1,"n_rows":55,"n_cols":28,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["LEVY INPUT PAGE - ASSUMPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Tax Levy Year:",2012,"Enter Year of Levy"]
[]
[null,"District Name:",null,"Enter District Name"]
[null,"District Number:",null,"Enter District Number"]
[null,"County 1:"]
[null,"County 2:"]
[null,"County 3:"]
[null,"County 4:"]
[null,null,"Fill out County names as needed - leave other boxes blank"]
[]
[null,"PTELL - Tax Capped:","Yes","Choose Yes or No"]
[]
[]
[null,"Original Tax Levy Certificate:","x"]
[null,"Amended Tax Levy Certificate:"]
[null,null,"Enter \"x\" in one box only"]
[]
[]
[null,"Consumer Price Index:",0.03,{"$f":"\"Enter CPI for Year ending \"&C3-1&\", for the \"&C3&\" Levy.\"","v":"Enter CPI for Year ending 2011, for the 2012 Levy."}]
[]
[null,{"$f":"\"Actual Total EAV for \"&C3-1&\":\"","v":"Actual Total EAV for 2011:"},null,{"$f":"\"Enter Actual rate setting EAV for \"&C3-1&\"\"","v":"Enter Actual rate setting EAV for 2011"}]
[null,{"$f":"\"Estimated % change from \"&C3-1&\" EAV:\"","v":"Estimated % change from 2011 EAV:"},null,"Enter reassessment percentage before New Construction"]
[]
[null,{"$f":"\"Estimated New Construction for \"&C3&\":\"","v":"Estimated New Construction for 2012:"},null,"Enter Estimated New Construction"]
[null,{"$f":"\"Estimated Total EAV for \"&C3&\":\"","v":"Estimated Total EAV for 2012:"},{"$f":"C23*(1+C24)+C26","v":0},"Includes New Construction"]
[null,"Total change from prior year:",{"$f":"C27/C23-1","v":{"$error":"#DIV/0!"}},"Includes New Construction"]
[]
[null,"No. of Tax Levied Bond Issues Outstanding:"]
[]
[]
[null,null,"Input Maximum Tax Rate:",{"$f":"\"Total \"&C3-1&\" Extension for all Counties:\"","v":"Total 2011 Extension for all Counties:"},{"$f":"\"Input \"&C3-1&\" \"&C7&\" County Extension:\"","v":"Input 2011  County Extension:"},{"$f":"IF(C8=\"\",\"\",\"Input \"&C3-1&\" \"&C8&\" County Extension:\")","v":""},{"$f":"IF(C9=\"\",\"\",\"Input \"&C3-1&\" \"&C9&\" County Extension:\")","v":""},{"$f":"IF(C10=\"\",\"\",\"Input \"&C3-1&\" \"&C10&\" County Extension:\")","v":""}]
[null,"Educational",null,{"$f":"SUM(E34:H34)","v":0}]
[null,"Operations & Maintenance",null,{"$f":"SUM(E35:H35)","v":0}]
[null,"Transportation",null,0]
[null,"Working Cash",null,0]
[null,"Municipal Retirement",null,0]
[null,"Social Security",null,0]
[null,"Fire Prevention & Safety  *",null,0]
[null,"Tort Immunity",null,0]
[null,"Special Education",null,0]
[null,"Leasing",null,0]
["Input Fund Name:"," ",null,0]
[]
[null,null,{"$f":"IF(C13=\"Yes\",\"Total Capped Extension for \"&C3-1&\":\",\"Total Aggregate Extension for \"&C3-1&\":\")","v":"Total Capped Extension for 2011:"},{"$f":"SUM(D34:D44)","v":0}]
[]
[null,null,"SEDOL  IMRF (Lake County Only)"]
[]
[null,null,{"$f":"\"Bond and Interest Extension for \"&C3-1&\":\"","v":"Bond and Interest Extension for 2011:"}]
[]
[null,null,{"$f":"\"Total \"&C3-1&\" Extension:\"","v":"Total 2011 Extension:"},{"$f":"D46+D50+D48","v":0}]
[]
["*  Includes Fire Prevention, Safety, Energy Conservation, Disabled"]
["  Accessibility, School Security, and Specified Repair Purposes."]

{"sheet":"Calculations","index":2,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,0,1,1],[4,1,4,3],[5,1,5,3],[11,7,12,7],[11,5,12,5],[11,6,12,6],[4,0,5,0]]}
[]
[{"$f":"Input!$C$3&\" LEVY CALCULATION PAGE \"","v":"2012 LEVY CALCULATION PAGE "},null,null,null,null,null,"Consumer Price Index:",{"$f":"Input!$C$21","v":0.03}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"\"Actual Total EAV for \"&Input!C3-1&\":\"","v":"Actual Total EAV for 2011:"},{"$f":"Input!$C$23","v":0}]
["Limiting Rate:","(Prior Year Extension x (1+Lesser of 5% or CPI))",null,null,null,null,{"$f":"\"Estimated % change from \"&Input!C3-1&\" EAV:\"","v":"Estimated % change from 2011 EAV:"},{"$f":"Input!$C$24","v":0}]
[null,"(Total EAV - New Construction)",null,null,null,null,null," "]
[null,null,null,null,null,null,{"$f":"\"Estimated New Construction for \"&Input!C3&\":\"","v":"Estimated New Construction for 2012:"},{"$f":"Input!$C$26","v":0}]
[null,null,null,null,null,null,{"$f":"\"Estimated Total EAV for \"&Input!C3&\":\"","v":"Estimated Total EAV for 2012:"},{"$f":"Input!$C$27","v":0}]
["Limiting Rate:",{"$f":"IF(Input!C13=\"Yes\",Input!D46*(1+MIN(0.05,Input!$C$21))/(Input!$C$27-Input!C26),\"N/A\")","v":{"$error":"#DIV/0!"}},null,null,null,null,"Total change from prior year:",{"$f":"Input!$C$28","v":{"$error":"#DIV/0!"}}]
["Estimated Capped Extension:",{"$f":"IF(Input!C13=\"Yes\",B9*Input!C27,\"N/A\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,{"$f":"IF(Input!C13=\"Yes\",\"Prorated Extension based on prior year extension:\",\"Individual Fund Estimated Maximum Extension:\")","v":"Prorated Extension based on prior year extension:"},{"$f":"IF(Input!C13=\"Yes\",\"Manual Override:\",\"Manual Override and Non-Capped funds levy input:\")","v":"Manual Override:"},"Balloon % input:"]
[null,"Prior Year Extension:","Maximum Tax Rate:","Individual Fund Estimated Maximum Extension:",null,null,null,null,null,"Levy Amount:"]
["Educational",{"$f":"Input!D34","v":0},{"$f":"Input!C34","v":0},{"$f":"C14*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B14/$B$26*$B$10,D14)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUND(IF(G14=\"\",F14*(1+H14),G14*(1+H14)),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J14>D14,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
["Operations & Maintenance",{"$f":"Input!D35","v":0},{"$f":"Input!C35","v":0},{"$f":"C15*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B15/$B$26*$B$10,D15)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUND(IF(G15=\"\",F15*(1+H15),G15*(1+H15)),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J15>D15,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
["Transportation",{"$f":"Input!D36","v":0},{"$f":"Input!C36","v":0},{"$f":"C16*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B16/$B$26*$B$10,D16)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(Input!C13=\"yes\",\"\",IF(J16>D16,\"EXCEEDS EST. MAX\",\"\"))","v":""}]
["Working Cash",{"$f":"Input!D37","v":0},{"$f":"Input!C37","v":0},{"$f":"C17*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B17/$B$26*$B$10,D17)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(J17>D17,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
["Municipal Retirement",{"$f":"Input!D38","v":0},null,{"$f":"IF(Input!C13=\"Yes\",\"$0.00 \",\"Input in Manual Override\")","v":"$0.00 "},null,{"$f":"IF(Input!$C$13=\"Yes\",B18/$B$26*$B$10,D18)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"}]
["Social Security",{"$f":"Input!D39","v":0},null,{"$f":"IF(Input!C13=\"Yes\",\"$0.00 \",\"Input in Manual Override\")","v":"$0.00 "},null,{"$f":"IF(Input!$C$13=\"Yes\",B19/$B$26*$B$10,D19)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"}]
["Fire Prevention & Safety  *",{"$f":"Input!D40","v":0},{"$f":"Input!C40","v":0},{"$f":"C20*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B20/$B$26*$B$10,D20)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(J20>D20,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
["Tort Immunity",{"$f":"Input!D41","v":0},null,{"$f":"IF(Input!C13=\"Yes\",\"$0.00 \",\"Input in Manual Override\")","v":"$0.00 "},null,{"$f":"IF(Input!$C$13=\"Yes\",B21/$B$26*$B$10,D21)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"}]
["Special Education",{"$f":"Input!D42","v":0},{"$f":"Input!C42","v":0},{"$f":"C22*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B22/$B$26*$B$10,D22)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(J22>D22,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
["Leasing",{"$f":"Input!D43","v":0},{"$f":"Input!C43","v":0},{"$f":"C23*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B23/$B$26*$B$10,D23)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(J23>D23,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"Input!B44","v":" "},{"$f":"Input!D44","v":0},{"$f":"Input!C44","v":0},{"$f":"C24*Input!$C$27","v":0},null,{"$f":"IF(Input!$C$13=\"Yes\",B24/$B$26*$B$10,D24)","v":{"$error":"#DIV/0!"}},null,null,null,{"$error":"#DIV/0!"},{"$f":"IF(J24>D24,\"EXCEEDS EST. MAX\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Truth in Taxation"]
[{"$f":"IF(Input!C13=\"Yes\",\"Capped Extension/Levy\",\"Extension/Levy\")","v":"Capped Extension/Levy"},{"$f":"SUM(B14:B24)","v":0},null,{"$f":"SUM(D14:D24)","v":0},null,{"$f":"SUM(F14:F24)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G14:G25)","v":0},{"$f":"IF(Input!C13=\"Yes\",\"Capped Levy\",\"Levy\")","v":"Capped Levy"},null,{"$f":"SUM(J14:J24)","v":{"$error":"#DIV/0!"}},{"$f":"J26/B26-1","v":{"$error":"#DIV/0!"}},{"$f":"IF(K26>0.05,\"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Levy in excess of estimated extension:",{"$f":"IF(Input!C13=\"Yes\",J26-B10,\"N/A\")","v":{"$error":"#DIV/0!"}}]
[]
["SEDOL IMRF",{"$f":"Input!D48","v":0},null,null,null,"SEDOL IMRF",null,null,null,{"$f":"G30","v":0}]
[]
["Bond and Interest:",{"$f":"Input!D50","v":0},null,null,null,"Bond and Interest:",null,null,null,{"$f":"G32","v":0},{"$f":"J32/B32-1","v":{"$error":"#DIV/0!"}}]
[]
["Total Extension/Levy",{"$f":"B26+B32+B30","v":0},null,null,null,null,null,"Total Levy",null,{"$f":"J26+J32+J30","v":{"$error":"#DIV/0!"}},{"$f":"J34/B34-1","v":{"$error":"#DIV/0!"}}]

{"sheet":"copyright_disclaimer","index":3,"n_rows":93,"n_cols":3,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Follow these steps to view and set the macro security level in Excel 2007:"]
["1.         Click the Microsoft Office Button           and then click Excel Options."]
["2.         Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
["3.         Click the options that you want:"]
["·         Disable all macros without notification"]
["·         Disable all macros with notification"]
["·         Disable all macros except digitally signed macros "]
["·         Enable all macros (not recommended, potentially dangerous code can run)"]
["·         Trust access to the VBA project object model "]
[]
[]
[]
[]
[]
[null,null,"Follow these steps to view and set the macro security level in Excel 2010:"]
[null,null,"1.     Click the File tab and then click Options."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2.     Click the Trust Center tab and then click the Trust Center Settings button."]
[null,null,"The Trust Center dialog box appears with the Macro Settings tab selected."]
[null,null,"Select a security level: Enable all macros"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3.     Close the excel file, reopen the file."]

{"sheet":"Certificate of Tax Levy","index":4,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":true,"merged":[[61,11,61,12],[58,0,58,12],[34,2,34,3],[36,2,36,3],[21,3,21,4],[20,10,20,11],[32,2,32,3],[33,2,33,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[5,0,5,12],[15,10,15,11],[16,10,16,11],[17,10,17,11],[11,10,11,15],[11,0,11,5],[11,6,11,9],[16,3,16,4],[17,3,17,4],[66,0,66,1],[62,9,62,10],[65,8,65,10],[68,7,68,11],[71,7,71,11],[71,1,71,3],[67,7,67,11],[70,7,70,11],[70,1,70,3],[65,13,65,14],[21,10,21,11],[15,3,15,4],[60,9,60,11],[62,6,62,7],[37,2,37,3],[38,2,38,3],[18,3,18,4],[18,10,18,11],[19,10,19,11],[40,2,40,3],[41,2,41,3],[40,8,40,11],[41,8,41,11],[19,3,19,4],[20,3,20,4]]}
[null,null,null,"ILLINOIS STATE BOARD OF EDUCATION"]
[null,"Original:",{"$f":"IF(Input!$C$16=0,\"\",Input!$C$16)","v":"x"},"School Business and Support Services Division"]
[null,"Amended:",{"$f":"IF(Input!$C$17=0,\"\",Input!$C$17)","v":""},null,null,"217/785-8779"]
[]
[]
["CERTIFICATE OF TAX LEVY"]
[]
["A copy of this Certificate of Tax Levy shall be filed with the County Clerk of each county in which the school district is located "]
["on or before the last Tuesday of December."]
[]
["District Name",null,null,null,null,null,"District Number",null,null,null,"County"]
[{"$f":"Input!C5","v":0},null,null,null,null,null,{"$f":"Input!$C$6","v":0},null,null,null,{"$f":"IF(Input!$C$8=0,Input!C7,IF(Input!C9=0,Input!C7&\", \"&Input!C8,IF(Input!C10=0,Input!C7&\", \"&Input!C8&\", \"&Input!C9,Input!C7&\", \"&Input!C8&\", \"&Input!C9&\", \"&Input!C10)))","v":0}]
[]
["Amount of Levy"]
[]
["Educational",null,"$",{"$f":"Calculations!J14","v":{"$error":"#DIV/0!"}},null,null,"Fire Prevention & Safety  *",null,null,"$",{"$f":"Calculations!J20","v":{"$error":"#DIV/0!"}}]
["Operations & Maintenance",null,"$",{"$f":"Calculations!J15","v":{"$error":"#DIV/0!"}},null,null,"Tort Immunity",null,null,"$",{"$f":"Calculations!J21","v":{"$error":"#DIV/0!"}}]
["Transportation",null,"$",{"$f":"Calculations!J16","v":{"$error":"#DIV/0!"}},null,null,"Special Education",null,null,"$",{"$f":"Calculations!J22","v":{"$error":"#DIV/0!"}}]
["Working Cash",null,"$",{"$f":"Calculations!J17","v":{"$error":"#DIV/0!"}},null,null,"Leasing",null,null,"$",{"$f":"Calculations!J23","v":{"$error":"#DIV/0!"}}]
["Municipal Retirement",null,"$",{"$f":"Calculations!J18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Input!B44","v":" "},null,null,"$",{"$f":"Calculations!J24","v":{"$error":"#DIV/0!"}}]
["Social Security",null,"$",{"$f":"Calculations!J19","v":{"$error":"#DIV/0!"}},null,null,"Other",null,null,"$",{"$f":"Calculations!J30","v":0}]
[null,null,null,null,null,null,"Total Levy",null,null,"$",{"$f":"SUM(K16:L21)+SUM(D16:E21)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"*  Includes Fire Prevention, Safety, Energy Conservation, Disabled Accessibility, School Security, "]
["See explanation on reverse side.",null,null,null,null,null,"   and Specified Repair Purposes."]
["Note:     Any district proposing to adopt a levy must comply with"]
["the provisions set forth in the Truth in Taxation Law."]
[]
["We hereby certify that we require:"]
[null,"the sum of ",{"$f":"D16","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for educational purposes; and"]
[null,"the sum of ",{"$error":"#DIV/0!"},null,"dollars to be levied as a special tax for operations and maintenance purposes; and"]
[null,"the sum of ",{"$error":"#DIV/0!"},null,"dollars to be levied as a special tax for transportation purposes; and"]
[null,"the sum of ",{"$error":"#DIV/0!"},null,"dollars to be levied as a special tax for a working cash fund; and"]
[null,"the sum of ",{"$error":"#DIV/0!"},null,"dollars to be levied as a special tax for municipal retirement purposes; and"]
[null,"the sum of ",{"$error":"#DIV/0!"},null,"dollars to be levied as a special tax for social security purposes; and"]
[null,"the sum of ",{"$f":"K16","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for fire prevention, safety, energy conservation,"]
[null,null,null,null,"disabled accessibility, school security and specified repair purposes; and"]
[null,"the sum of ",{"$f":"K17","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for tort immunity purposes; and"]
[null,"the sum of ",{"$f":"K18","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for special education purposes; and"]
[null,"the sum of ",{"$f":"K19","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for leasing of educational facilities "]
[null,null,null,null,"or computer technology or both, and temporary relocation expense purposes; and"]
[null,"the sum of ",{"$f":"K20","v":{"$error":"#DIV/0!"}},null,"dollars to be levied as a special tax for ",null,null,null,{"$f":"IF(Input!$B$44=0,\"\",Input!$B$44)","v":" "},null,null,null,"; and"]
[null,"the sum of ",{"$f":"K21","v":0},null,"dollars to be levied as a special tax for ",null,null,null,{"$f":"IF(Input!$D$48=0,\"\",Input!$E$48)","v":""}]
[null,"on the taxable property of our school district for the year ",null,null,null,null,null,{"$f":"Input!$C$3","v":2012}]
[]
["Signed this ",null,"day of",null,{"$f":"Input!$C$3","v":2012},null,"."]
[null,null,null,null,null,null,null,null,null,"(President)"]
[]
[]
[null,null,null,null,null,null,"(Clerk or Secretary of the School Board of Said School District)"]
[]
["When any school is authorized to issue bonds, the school board shall file a certified copy of the resolution in the office of the county clerk of each county in which the district is"]
["situated to provide for the issuance of the bonds and to levy a tax to pay for them.  The county clerk shall extend the tax for bonds and interest as set forth in the certified copy"]
["of the resolution, each year during the life of the bond issue.  Therefore to avoid a possible duplication of tax levies, the school board should not include a levy for bonds and"]
["interest in the district's annual tax levy."]
[]
["Number of bond issues of said school district that have not been paid in full",null,null,null,null,null,null,null,null,null,{"$f":"Input!C30","v":0},"."]
[]
[]
["(Detach and Return to School District)"]
[]
["This is to certify that the Certificate of Tax Levy for School District No.",null,null,null,null,null,null,{"$f":"G12","v":0},",",{"$f":"K12","v":0},null,null,"County,"]
["Illinois, on the equalized assesed value of all taxable property of said school district for the year ",null,null,null,null,null,null,null,null,null,null,{"$f":"H43","v":2012},","]
["was filed in the office of the County Clerk of this County on",null,null,null,null,null,null,null,",",{"$f":"H43","v":2012},null,"."]
["In addition to an extension of taxes authorized by levies made by the Board of Education (Directors), an additional extension(s)"]
["will be made, as authorized by resolution(s) on file in this office, to provide funds to retire bonds and pay interest thereon.  "]
["The total levy, as provided in the original resolution(s), for said purposes for the year",null,null,null,null,null,null,null,{"$f":"Input!$C$3","v":2012},null,null,", is","$",null,null,"."]
[]
[]
[null,null,null,null,null,null,null,"(Signature of County Clerk)"]
[]
[]
[null,"(Date)",null,null,null,null,null,"(County)"]
[]
[]
["copy of ISBE Form 50-02 (08/2009) ctl2009.xls"]

{"sheet":"Explanation","index":5,"n_rows":69,"n_cols":1,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["EXPLANATION"]
["The school board of any school district having a population of less than 500,000 inhabitants may levy a tax annually, for"]
["educational purposes, upon all the taxable property of the district at the value, as equalized or assessed by the Department of "]
["Revenue (Section 17-2 of the School Code)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may levy a tax annually, for"]
["operations and maintenance purposes, upon all the taxable property of the district at the value, as equalized or assessed "]
["by the Department of Revenue (Section 17-2 of the School Code)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may levy a tax annually, for "]
["transportation purposes, upon all the taxable property of the district at the value, as equalized or assessed by the Department "]
["of Revenue (Section 17-2 of the School Code)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may levy a tax known as a "]
["Working Cash Fund Tax upon all the taxable property of the district, annually  (Section 20-3 of the School Code)."]
[]
["The school board of any school district may levy a tax for municipal retirement purposes in a sum sufficient to provide all the"]
["contributions required of the school district by including the amount to be levied for such purposes in the Certificate of Tax Levy"]
["for other school taxes, or such district may file with the county clerk a separate certificate or resolution setting forth the amount"]
["of tax to be levied for such purpose (40 ILCS 5/7-171)."]
[]
["The school board of any school district may levy a tax for social security (includes Medicare only) purposes in a sum"]
["sufficient to provide all the contributions required of the school district by including the amount to be levied for such purposes"]
["in the Certificate of Tax Levy for other taxes, or such district may file with the county clerk a separate certificate or resolution"]
["setting forth the amount of tax to be levied for such purpose (40 ILCS 5/21-110, 21-110.1)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may levy a tax upon all the"]
["taxable property of the district at the value as equalized or assessed by the Department of Revenue for the purposes of"]
["professional surveys, alterations, and reconstruction for fire prevention, safety, energy conservation, disabled accessibility,"]
["school security, and specified repair purposes upon meeting certain statutory conditions (Section 17-2.11 of the School Code)."]
[]
["The school board of any school district may levy a tax upon all the taxable property within the district for tort immunity"]
["purposes in a sum sufficient to pay the costs of purchasing such insurance or sufficient to pay any tort judgment, settlement,"]
["or insurance imposed upon it under the Local Government and Governmental Employees Tort Immunity Act including liabilities"]
["under the Workers' Compensation Act, Occupational Diseases Act, or the Unemployment Insurance Act 745 ILCS 10/9-107"]
["and Section 17-2.5 of the School Code)."]
[]
[]
["The school board of any school district may levy, with voter approval, a tax upon the full, fair cash value as equalized or"]
["assessed by the Department of Revenue within the district for a capital improvement fund (which levy is in addition to that for"]
["building purposes) and such fund is to be levied, accumulated, and spent only in accordance with Section 17-2.3 of the School"]
["Code."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants, by proper resolution, may levy"]
["an annual tax upon the full, fair cash value as equalized or assessed by the Department of Revenue for special education "]
["purposes including the purposes authorized by Section 10-22.31b and Section 17-2.2a of the School Code."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants, with voter approval, may levy "]
["a tax annually, for summer school purposes, upon all the taxable property of the district at the value, as equalized or assessed"]
["by the Department of Revenue (Section 17-2.1 of the School Code)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may, by proper resolution, levy "]
["an annual tax upon the value as equalized or assessed by the Department of Revenue for a period of not more than five years"]
["for area vocational education building purposes including the purposes authorized by Section 10-22.31b of the School Code,"]
["upon the condition that there are not sufficient funds available in the operations and maintenance fund of the district to pay the"]
["cost thereof.  Such tax shall not be levied without the prior approval of the State Superintendent of Education and prior approval"]
["by a majority of the electors voting upon the proposition at a general or special election (Section 17-2.4 of the School Code)."]
[]
["The school board of any school district having a population of less than 500,000 inhabitants may levy an annual tax not to"]
["exceed 0.05% upon the taxable property, as equalized or assessed by the Department of Revenue, for the purposes of leasing"]
["educational facilities or computer technology or both, and for temporary relocation expense (Section 17-2.2c of the School Code)."]
[]
["The school board of any school district, upon determining that a surplus of funds is available, shall adopt a resolution or "]
["ordinance reducing the tax levy of such district for the year for which the resolution or ordinance is adopted.  The district shall"]
["certify the action to the county clerk who shall abate the levy in accordance with the provision of the ordinance (35 "]
["ILCS 200/18-20)."]
[]
["The Truth in Taxation Law affects all units of local government, school districts, and community colleges, including home rule"]
["units, who are authorized to levy property taxes.  For the requirements of the law, refer to 35 ILCS 200/18-55 et seq.  "]

{"sheet":"Extension","index":6,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[[4,0,5,0],[13,7,14,7],[13,8,14,8],[1,0,1,2],[13,12,14,12],[13,6,14,6],[8,2,8,3],[7,2,7,3],[9,2,9,3],[13,9,14,9]]}
[]
[{"$f":"Input!$C$3&\" TAX EXTENSION WORKSHEET\"","v":"2012 TAX EXTENSION WORKSHEET"},null,null,null,null,null,null,{"$f":"\"Estimated New Construction for \"&Input!$C$3&\":\"","v":"Estimated New Construction for 2012:"},{"$f":"Input!$C$26","v":0}]
[null,null,null,null,null,null,null,{"$f":"\"Estimated Total EAV for \"&Input!$C$3&\":\"","v":"Estimated Total EAV for 2012:"},{"$f":"Input!$C$27","v":0}]
[null,null,null,null,null,null,null,"Estimated change from prior year:",{"$f":"Input!$C$28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,{"$f":"\"Actual New Construction for \"&Input!$C$3&\":\"","v":"Actual New Construction for 2012:"}]
[null,null,null,null,null,null,null,{"$f":"\"Actual Total EAV for \"&Input!$C$3&\":\"","v":"Actual Total EAV for 2012:"}]
[null,"Estimate:","Actual:",null,null,null,null,"Actual change from prior year:",{"$f":"I7/Input!$C$23-1","v":{"$error":"#DIV/0!"}}]
["Limiting Rate:",{"$f":"IF(Input!C13=\"Yes\",Input!$D$46*(1+MIN(0.05,Input!$C$21))/(Input!$C$27-Input!$C$26),\"N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!C13=\"Yes\",Input!$D$46*(1+MIN(0.05,Input!$C$21))/(I7-I6),\"N/A\")","v":{"$error":"#DIV/0!"}}]
["Capped Extension:",{"$f":"IF(Input!C13=\"Yes\",$B$9*Input!$C$27,\"N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!C13=\"Yes\",$C$9*$I$7,\"N/A\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Reduction Factor:",{"$f":"IF(C9>G28,\"N/A\",$C$9/$G$28)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(I11=\"N/A\",\"Amount Below Allowable PTELL:\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(I11=\"N/A\",I28-C10,\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Maximum Calculated Tax Rate:","Maximum Allowable Extension:","Maximum Allowable Extension x Reduction Factor:","Final Tax Rate:",null,null,"Final Adjusted Tax Rate:"]
[null,"Levy Amount:","County Loss %:",null,"Total Levy with Loss & Cost:","Calculated Tax Rate:",null,null,null,null,null,"District Adjustment:"]
["Educational",{"$f":"Calculations!J14","v":{"$error":"#DIV/0!"}},0,null,{"$f":"B16*(1+C16)","v":{"$error":"#DIV/0!"}},{"$f":"E16/$I$7","v":{"$error":"#DIV/0!"}},{"$f":"IF(Input!C34>0,MIN(Input!C34,F16),F16)","v":{"$error":"#DIV/0!"}},{"$f":"G16*$I$7","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$11=\"N/A\",H16,H16*$I$11)","v":{"$error":"#DIV/0!"}},{"$f":"I16/$I$7","v":{"$error":"#DIV/0!"}},null,0,{"$f":"IF(L16=0,J16,L16/$I$7)","v":{"$error":"#DIV/0!"}}]
["Operations & Maintenance",{"$f":"Calculations!J15","v":{"$error":"#DIV/0!"}},0,null,{"$f":"B17*(1+C17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(Input!C35>0,MIN(Input!C35,F17),F17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"I17/$I$7","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
["Transportation",{"$f":"Calculations!J16","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C36>0,MIN(Input!C36,F18),F18)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Working Cash",{"$f":"Calculations!J17","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C37>0,MIN(Input!C37,F19),F19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Municipal Retirement",{"$f":"Calculations!J18","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C38>0,MIN(Input!C38,F20),F20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Social Security",{"$f":"Calculations!J19","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C39>0,MIN(Input!C39,F21),F21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Fire Prevention & Safety  *",{"$f":"Calculations!J20","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C40>0,MIN(Input!C40,F22),F22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Tort Immunity",{"$f":"Calculations!J21","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C41>0,MIN(Input!C41,F23),F23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Special Education",{"$f":"Calculations!J22","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C42>0,MIN(Input!C42,F24),F24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
["Leasing",{"$f":"Calculations!J23","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C43>0,MIN(Input!C43,F25),F25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[{"$f":"Input!B44","v":" "},{"$f":"Calculations!J24","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(Input!C44>0,MIN(Input!C44,F26),F26)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"}]
[]
[{"$f":"IF(Input!C13=\"Yes\",\"Capped Levy/Extension\",\"Levy/Extension\")","v":"Capped Levy/Extension"},{"$f":"SUM(B16:B26)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(E16:E26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F16:F26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G16:G26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H16:H26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I16:I27)","v":{"$error":"#DIV/0!"}},{"$f":"I28/$I$7","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(M16:M26)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29=0,\"\",\"% Needed To Adjust::\")","v":{"$error":"#DIV/0!"}},{"$f":"J28-M28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M30=0,\"\",\"Amount Needed To Adjust:\")","v":{"$error":"#DIV/0!"}},{"$f":"I7*M29","v":{"$error":"#DIV/0!"}}]
[]
["SEDOL IMRF",{"$f":"Calculations!J30","v":0},null,null,null,null,null,"SEDOL IMRF",null,{"$f":"I32/$I$7","v":{"$error":"#DIV/0!"}},null,{"$f":"I32","v":0},{"$f":"L32/$I$7","v":{"$error":"#DIV/0!"}}]
[]
["Bond and Interest:",{"$f":"Calculations!J32","v":0},null,null,null,null,null,"Bond and Interest:",null,{"$f":"I34/$I$7","v":{"$error":"#DIV/0!"}},null,{"$f":"I34","v":0},{"$f":"L34/$I$7","v":{"$error":"#DIV/0!"}}]
[]
["Total Extension/Levy",{"$f":"B28+B34+B32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"I28+I34+I32","v":{"$error":"#DIV/0!"}},{"$f":"J28+J32+J34","v":{"$error":"#DIV/0!"}},null,{"$f":"L28+L34+L32","v":0},{"$f":"M28+M32+M34","v":{"$error":"#DIV/0!"}}]

{"sheet":"InfoPage","index":7,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Password:","CTL02"]